object frmCartaoBaixas: TfrmCartaoBaixas
  Left = 254
  Top = 165
  AutoScroll = False
  Caption = 'Cart'#227'o'
  ClientHeight = 506
  ClientWidth = 593
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  FormStyle = fsMDIChild
  OldCreateOrder = False
  Position = poDefault
  Visible = True
  OnClose = FormClose
  OnCreate = FormCreate
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object Panel3: TPanel
    Left = 0
    Top = 0
    Width = 593
    Height = 40
    Align = alTop
    BevelInner = bvLowered
    BorderWidth = 2
    Caption = 'Baixa de Cart'#245'es'
    Color = clWhite
    Ctl3D = True
    Font.Charset = ANSI_CHARSET
    Font.Color = clBlue
    Font.Height = -27
    Font.Name = 'Times New Roman'
    Font.Style = [fsBold, fsItalic]
    ParentCtl3D = False
    ParentFont = False
    TabOrder = 1
  end
  object pnlFiltros: TPanel
    Left = 0
    Top = 40
    Width = 593
    Height = 89
    Align = alTop
    TabOrder = 0
    object Label1: TLabel
      Left = 8
      Top = 4
      Width = 41
      Height = 13
      Caption = 'Empresa'
    end
    object Label2: TLabel
      Left = 8
      Top = 44
      Width = 31
      Height = 13
      Caption = 'Cart'#227'o'
    end
    object Label3: TLabel
      Left = 314
      Top = 44
      Width = 38
      Height = 13
      Caption = 'Per'#237'odo'
    end
    object Label4: TLabel
      Left = 402
      Top = 66
      Width = 6
      Height = 13
      Caption = 'a'
    end
    object edtEmpresa: TEdit
      Left = 8
      Top = 18
      Width = 42
      Height = 21
      CharCase = ecUpperCase
      TabOrder = 0
      OnExit = edtEmpresaExit
    end
    object btnEmpresa: TBitBtn
      Left = 52
      Top = 18
      Width = 22
      Height = 22
      Caption = '...'
      TabOrder = 1
      TabStop = False
      OnClick = btnEmpresaClick
    end
    object stEmpresa: TStaticText
      Left = 75
      Top = 18
      Width = 233
      Height = 21
      AutoSize = False
      BorderStyle = sbsSingle
      TabOrder = 2
    end
    object edtCartao: TEdit
      Left = 8
      Top = 58
      Width = 42
      Height = 21
      CharCase = ecUpperCase
      TabOrder = 3
      OnExit = edtCartaoExit
    end
    object btnCartao: TBitBtn
      Left = 52
      Top = 58
      Width = 22
      Height = 22
      Caption = '...'
      TabOrder = 4
      TabStop = False
      OnClick = btnCartaoClick
    end
    object stCartao: TStaticText
      Left = 75
      Top = 58
      Width = 233
      Height = 21
      AutoSize = False
      BorderStyle = sbsSingle
      TabOrder = 5
    end
    object rgBaixado: TRadioGroup
      Left = 314
      Top = 4
      Width = 191
      Height = 39
      Caption = 'Exibir'
      Columns = 2
      ItemIndex = 1
      Items.Strings = (
        'Baixados'
        'Em Aberto')
      TabOrder = 6
    end
    object edtInicio: TEdit
      Left = 314
      Top = 59
      Width = 75
      Height = 21
      CharCase = ecUpperCase
      TabOrder = 7
      OnExit = edtInicioExit
    end
    object edtFinal: TEdit
      Left = 425
      Top = 60
      Width = 75
      Height = 21
      CharCase = ecUpperCase
      TabOrder = 8
      OnExit = edtInicioExit
    end
    object btnLocalizar: TBitBtn
      Left = 512
      Top = 16
      Width = 75
      Height = 25
      Caption = 'Localizar'
      TabOrder = 9
      OnClick = btnLocalizarClick
      NumGlyphs = 2
    end
    object btnCancela: TBitBtn
      Left = 512
      Top = 56
      Width = 75
      Height = 25
      Caption = 'Cancelar'
      Enabled = False
      TabOrder = 10
      OnClick = btnCancelaClick
    end
  end
  object pnlBaixa: TPanel
    Left = 0
    Top = 338
    Width = 593
    Height = 168
    Align = alBottom
    TabOrder = 2
    object Label11: TLabel
      Left = 433
      Top = 9
      Width = 61
      Height = 13
      Caption = 'Data Receb.'
    end
    object Label12: TLabel
      Left = 505
      Top = 9
      Width = 79
      Height = 13
      Caption = 'Valor Receb. R$'
    end
    object Label14: TLabel
      Left = 5
      Top = 50
      Width = 34
      Height = 13
      Caption = 'Banco:'
    end
    object Label15: TLabel
      Left = 4
      Top = 88
      Width = 31
      Height = 13
      Caption = 'Conta:'
    end
    object Label16: TLabel
      Left = 517
      Top = 88
      Width = 42
      Height = 13
      Caption = 'Ag'#234'ncia:'
    end
    object Label6: TLabel
      Left = 5
      Top = 8
      Width = 39
      Height = 13
      Caption = 'Emiss'#227'o'
    end
    object Label7: TLabel
      Left = 79
      Top = 8
      Width = 56
      Height = 13
      Caption = 'Vencimento'
    end
    object Label10: TLabel
      Left = 153
      Top = 8
      Width = 77
      Height = 13
      Caption = 'Valor a Receber'
    end
    object Label5: TLabel
      Left = 234
      Top = 8
      Width = 57
      Height = 13
      Caption = 'Data Antec.'
    end
    object Label8: TLabel
      Left = 304
      Top = 8
      Width = 58
      Height = 13
      Caption = 'Taxa Antec.'
    end
    object Label9: TLabel
      Left = 369
      Top = 8
      Width = 62
      Height = 13
      Caption = 'Desc. Antec.'
    end
    object edtDataRec: TEdit
      Left = 433
      Top = 24
      Width = 67
      Height = 21
      CharCase = ecUpperCase
      Enabled = False
      TabOrder = 3
      OnExit = edtInicioExit
    end
    object edtValorRec: TEdit
      Left = 504
      Top = 24
      Width = 79
      Height = 21
      CharCase = ecUpperCase
      Enabled = False
      TabOrder = 4
    end
    object edt_banco: TEdit
      Left = 5
      Top = 65
      Width = 49
      Height = 21
      Enabled = False
      TabOrder = 5
      OnExit = edt_bancoExit
    end
    object btn_banco: TBitBtn
      Left = 56
      Top = 65
      Width = 21
      Height = 21
      Caption = '...'
      Enabled = False
      TabOrder = 6
      TabStop = False
      OnClick = btn_bancoClick
    end
    object st_banco: TStaticText
      Left = 78
      Top = 65
      Width = 503
      Height = 21
      AutoSize = False
      BorderStyle = sbsSingle
      TabOrder = 11
    end
    object edt_conta: TEdit
      Left = 4
      Top = 104
      Width = 65
      Height = 21
      Enabled = False
      TabOrder = 7
      OnExit = edt_contaExit
    end
    object btn_conta: TBitBtn
      Left = 71
      Top = 104
      Width = 21
      Height = 21
      Caption = '...'
      Enabled = False
      TabOrder = 8
      TabStop = False
      OnClick = btn_contaClick
    end
    object st_conta: TStaticText
      Left = 94
      Top = 104
      Width = 416
      Height = 21
      AutoSize = False
      BorderStyle = sbsSingle
      TabOrder = 12
    end
    object edt_agencia: TEdit
      Left = 517
      Top = 104
      Width = 65
      Height = 21
      Enabled = False
      TabOrder = 9
    end
    object btnBaixar: TBitBtn
      Left = 509
      Top = 138
      Width = 75
      Height = 25
      Caption = 'Baixar'
      Enabled = False
      TabOrder = 10
      OnClick = btnBaixarClick
    end
    object DBEdit2: TDBEdit
      Left = 5
      Top = 24
      Width = 70
      Height = 21
      BevelInner = bvNone
      BevelOuter = bvNone
      Color = clBtnFace
      DataField = 'EMISSAO'
      DataSource = DtsGrid
      TabOrder = 13
    end
    object DBEdit3: TDBEdit
      Left = 79
      Top = 24
      Width = 70
      Height = 21
      BevelInner = bvNone
      BevelOuter = bvNone
      Color = clBtnFace
      DataField = 'VENCIMENTO'
      DataSource = DtsGrid
      TabOrder = 14
    end
    object edtAReceber: TEdit
      Left = 153
      Top = 24
      Width = 77
      Height = 21
      BevelInner = bvNone
      BevelOuter = bvNone
      CharCase = ecUpperCase
      Color = clBtnFace
      TabOrder = 15
    end
    object edtDataAntec: TEdit
      Left = 234
      Top = 24
      Width = 67
      Height = 21
      CharCase = ecUpperCase
      Enabled = False
      TabOrder = 0
      OnExit = edtInicioExit
    end
    object edtTaxaAntec: TEdit
      Left = 304
      Top = 24
      Width = 61
      Height = 21
      CharCase = ecUpperCase
      Enabled = False
      TabOrder = 1
      OnExit = edtTaxaAntecExit
    end
    object edtDescAntec: TEdit
      Left = 369
      Top = 24
      Width = 61
      Height = 21
      CharCase = ecUpperCase
      Enabled = False
      TabOrder = 2
    end
  end
  object Panel1: TPanel
    Left = 0
    Top = 129
    Width = 593
    Height = 209
    Align = alClient
    Caption = 'Panel1'
    TabOrder = 3
    object DBGrid1: TDBGrid
      Left = 1
      Top = 1
      Width = 591
      Height = 207
      Align = alClient
      DataSource = DtsGrid
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit, dgMultiSelect]
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
      OnCellClick = DBGrid1CellClick
      Columns = <
        item
          Expanded = False
          FieldName = 'DOCUMENTO'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'SEQ'
          Title.Caption = 'PARCELA'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'EMISSAO'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'VENCIMENTO'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'VALORPARCELA'
          Title.Caption = 'VALOR'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'TAXAPARCELA'
          Title.Caption = 'TAXA'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'VALORRECEBER'
          Title.Caption = 'VALOR_A_RECEBER'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'LOTE'
          Visible = True
        end>
    end
  end
  object DtsGrid: TDataSource
    DataSet = SQLC_Cartao
    Left = 152
    Top = 145
  end
  object SQLC_Cartao: TSQLClientDataSet
    CommandText = 
      'SELECT '#13#10'  CAL_DOCUMENTO DOCUMENTO,'#13#10'  CAL_DATA EMISSAO,'#13#10'  CAL_' +
      'VALOR VALOR, '#13#10'  CAL_TAXA TAXA,'#13#10'  CAL_LOTE LOTE,'#13#10'  CAL_CONTA C' +
      'ONTA,'#13#10'  CAL_SUBCONTA SUBCONTA,'#13#10'  CAL_EMPRESA EMPRESA,'#13#10'  CAL_P' +
      'ARCELAS PARCELAS,'#13#10'  CLP_IDFDOCUMENTO DOC,'#13#10'  CLP_SEQ_PARCELA SE' +
      'Q,'#13#10'  CLP_DATA_VENCIMENTO VENCIMENTO,'#13#10'  CLP_VALOR VALORPARCELA,' +
      #13#10'  CLP_TAXA TAXAPARCELA,'#13#10'  CLP_DATA_RECEBIMENTO DTRECEBIMENTO,' +
      #13#10'  CLP_VALOR_A_RECEBER VALORRECEBER,'#13#10'  CLP_VALOR_RECEBIDO VALO' +
      'RRECEBIDO,'#13#10'  CLP_DATA_ANTECIPA DATAANTEC,'#13#10'  CLP_TAXA_ANTECIPA ' +
      'TAXAANTEC,'#13#10'  CLP_DESC_ANTECIPA DESCANTEC,'#13#10'  CLP_DTHBAIXA DATAB' +
      'AIXA,'#13#10'  CLP_USRBAIXA USUBAIXA,'#13#10'  CLP_BANCOLANIDF BANCOLANC '#13#10'F' +
      'ROM CARTAO_LANCAMENTO '#13#10'INNER JOIN CARTAO_LANCAMENTO_PARCELAS '#13#10 +
      'ON (CAL_IDFDOCUMENTO=CLP_IDFDOCUMENTO) '
    Aggregates = <>
    Options = [poAllowCommandText]
    ObjectView = True
    Params = <>
    AfterOpen = SQLC_CartaoAfterOpen
    AfterClose = SQLC_CartaoAfterClose
    DBConnection = DtmGeral.ConexaoBanco
    Left = 192
    Top = 145
    object SQLC_CartaoDOCUMENTO: TStringField
      FieldName = 'DOCUMENTO'
      Required = True
      Size = 13
    end
    object SQLC_CartaoEMISSAO: TDateField
      FieldName = 'EMISSAO'
      Required = True
    end
    object SQLC_CartaoVALOR: TFMTBCDField
      FieldName = 'VALOR'
      Required = True
      DisplayFormat = '0.00'
      Precision = 15
      Size = 8
    end
    object SQLC_CartaoTAXA: TFMTBCDField
      FieldName = 'TAXA'
      Required = True
      DisplayFormat = '0.00'
      Precision = 15
      Size = 8
    end
    object SQLC_CartaoLOTE: TStringField
      FieldName = 'LOTE'
      Size = 13
    end
    object SQLC_CartaoVENCIMENTO: TDateField
      FieldName = 'VENCIMENTO'
      Required = True
    end
    object SQLC_CartaoVALORPARCELA: TFMTBCDField
      FieldName = 'VALORPARCELA'
      Required = True
      DisplayFormat = '0.00'
      Precision = 15
      Size = 8
    end
    object SQLC_CartaoTAXAPARCELA: TFMTBCDField
      FieldName = 'TAXAPARCELA'
      DisplayFormat = '0.00'
      Precision = 15
      Size = 8
    end
    object SQLC_CartaoVALORRECEBER: TFMTBCDField
      FieldName = 'VALORRECEBER'
      Required = True
      DisplayFormat = '0.00'
      Precision = 15
      Size = 8
    end
    object SQLC_CartaoDTRECEBIMENTO: TDateField
      FieldName = 'DTRECEBIMENTO'
    end
    object SQLC_CartaoVALORRECEBIDO: TFMTBCDField
      FieldName = 'VALORRECEBIDO'
      DisplayFormat = '0.00'
      Precision = 15
      Size = 8
    end
    object SQLC_CartaoDATAANTEC: TDateField
      FieldName = 'DATAANTEC'
    end
    object SQLC_CartaoTAXAANTEC: TFMTBCDField
      FieldName = 'TAXAANTEC'
      DisplayFormat = '0.00'
      Precision = 15
      Size = 8
    end
    object SQLC_CartaoDESCANTEC: TFMTBCDField
      FieldName = 'DESCANTEC'
      DisplayFormat = '0.00'
      Precision = 15
      Size = 8
    end
    object SQLC_CartaoDATABAIXA: TSQLTimeStampField
      FieldName = 'DATABAIXA'
    end
    object SQLC_CartaoUSUBAIXA: TStringField
      FieldName = 'USUBAIXA'
      Size = 3
    end
    object SQLC_CartaoBANCOLANC: TIntegerField
      FieldName = 'BANCOLANC'
    end
    object SQLC_CartaoDOC: TIntegerField
      FieldName = 'DOC'
      Required = True
    end
    object SQLC_CartaoSEQ: TIntegerField
      FieldName = 'SEQ'
      Required = True
    end
    object SQLC_CartaoPARCELAS: TIntegerField
      FieldName = 'PARCELAS'
      Required = True
    end
    object SQLC_CartaoCONTA: TStringField
      FieldName = 'CONTA'
      Required = True
      Size = 3
    end
    object SQLC_CartaoSUBCONTA: TStringField
      FieldName = 'SUBCONTA'
      Required = True
      Size = 3
    end
    object SQLC_CartaoEMPRESA: TSmallintField
      FieldName = 'EMPRESA'
      Required = True
    end
  end
  object DtSrc: TDataSource
    DataSet = SQLC_Baixa
    Left = 241
    Top = 242
  end
  object SQLC_Baixa: TSQLClientDataSet
    CommandText = 
      'SELECT '#13#10'  CLP_SEQ_PARCELA SEQPARCELA,'#13#10'  CLP_DATA_VENCIMENTO VE' +
      'NCIMENTO,'#13#10'  CLP_VALOR VALORPARCELA,'#13#10'  CLP_TAXA TAXAPARCELA,'#13#10' ' +
      ' CLP_DATA_RECEBIMENTO DTRECEBIMENTO,'#13#10'  CLP_VALOR_A_RECEBER VALO' +
      'RRECEBER,'#13#10'  CLP_VALOR_RECEBIDO VALORRECEBIDO,'#13#10'  CLP_DATA_ANTEC' +
      'IPA DATAANTEC,'#13#10'  CLP_TAXA_ANTECIPA TAXAANTEC,'#13#10'  CLP_DESC_ANTEC' +
      'IPA DESCANTEC,'#13#10'  CLP_DTHBAIXA DATABAIXA,'#13#10'  CLP_USRBAIXA USUBAI' +
      'XA,'#13#10'  CLP_BANCOLANIDF BANCOLANC '#13#10'FROM CARTAO_LANCAMENTO_PARCEL' +
      'AS '
    Aggregates = <>
    Options = [poAllowCommandText]
    ObjectView = True
    Params = <>
    DBConnection = DtmGeral.ConexaoBanco
    Left = 281
    Top = 242
  end
end
